package com.pwt.repository;

import com.pwt.repository.base.BaseRepository;
import com.pwt.entity.StatisticsPercent;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
 * StatisticsPercent Repository层
 *
 * @author auto generated
 * @date 2021-09-23 11:32:09
 */
public interface StatisticsPercentRepository extends BaseRepository<StatisticsPercent, String> {

    @Query(nativeQuery = true,value = "delete  from statistics_percent where product_statistics_id = ?1")
    @Modifying
    public int deleteByProductStatisticsId(String ProductStatisticsId);

    List<StatisticsPercent> getByProductStatisticsId(String id);
}
